inverted join
Short Description
An inverted join forces the optimizer to use a Generalized Inverted Index (GIN index) on the right side of the join
Detailed Description​
An inverted join force the optimizer to use a Generalized Inverted Index (GIN index) on the right side of the join. GIN indexes are used on container columns such as:
- JASONB documents
- Arrays
- Spatial Data
INVERTED JOINs can only be used with INNER and LEFT joins.
Additional Links​
- CockroachDB Docs - Inverted Joins
- CockroachDB Docs - Example on an Inverted Join
- CockroachDB Docs - Supported Join Algorithms
- CockroachDB Docs - Cost Based Optimizer
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.